﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Jzy.Model.CRM
{
    public partial class CustomerVisitInfo
    {
        public const string TABLE_NAME = "CustomerVisit";
        public const string INSERT_SQL = "insert into CustomerVisit ( [ID], [Name], [InputTime], [ContactName], [CustomerID], [ContactMethod], [IsDelete], [UserID], [UserName]) values ( @ID, @Name, @InputTime, @ContactName, @CustomerID, @ContactMethod, @IsDelete, @UserID, @UserName)";
        public const string UPDATE_SQL = "update CustomerVisit set  [ID] = @ID, [Name] = @Name, [InputTime] = @InputTime, [ContactName] = @ContactName, [CustomerID] = @CustomerID, [ContactMethod] = @ContactMethod, [IsDelete] = @IsDelete, [UserID] = @UserID, [UserName] = @UserName where ID = @ID";
        /// <summary>
        /// PK
        /// </summary>
        public Int32 ID
        {
            get;
            set;
        }
        /// <summary>
        /// 联系记录
        /// </summary>
        public String Name
        {
            get;
            set;
        }
        /// <summary>
        /// 联系时间
        /// </summary>
        public DateTime InputTime
        {
            get;
            set;
        }
        /// <summary>
        /// 对方联系人
        /// </summary>
        public String ContactName
        {
            get;
            set;
        }
        /// <summary>
        /// 客户ID
        /// </summary>
        public Int32 CustomerID
        {
            get;
            set;
        }
        /// <summary>
        /// 联系方法(qq,msn,电话)
        /// </summary>
        public Int32 ContactMethod
        {
            get;
            set;
        }
        /// <summary>
        /// 是否逻辑删除
        /// </summary>
        public Boolean IsDelete
        {
            get;
            set;
        }
        /// <summary>
        /// 我方人员ID
        /// </summary>
        public Int32 UserID
        {
            get;
            set;
        }
        /// <summary>
        /// 我方人员姓名
        /// </summary>
        public String UserName
        {
            get;
            set;
        }
    }


}
